Microsoft Excel PowerPivot

Master the art of business decision-making with Microsoft Excel PowerPivot, designed for Excel-savvy professionals seeking to harness data from various sources using powerful reporting and analytical tools.

Course Thumbnail

Essential Skills Gained

Checkmark

Become familiar with PowerPivot and import data effectively.

Checkmark

Manipulate and organize data within PowerPivot worksheets.

Checkmark

Create dynamic reports and visualizations from PowerPivot data.

Checkmark

Leverage DAX functions for advanced data manipulation in PowerPivot.

Format

  • Instructor-led
  • 1 days with lectures and hands-on labs.

Audience

  • Excel-savvy professionals
  • Business analysts
  • Data-driven decision makers
  • IT consultants

Description

You will make use of the PowerPivot add-in to import data from various sources and create a dynamic report.

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

Lesson 1: Getting Started with PowerPivot

  1. Explore the PowerPivot Application

  2. Import Data from Various Data Sources

  3. Refresh Data from a Data Source

  4. Create Linked Tables

Lesson 2: Manipulating PowerPivot Data

  1. Organize and Format Tables

  2. Create Calculated Columns

  3. Sort and Filter PowerPivot Data

  4. Create and Manage Table Relationships

Lesson 3: Creating PowerPivot Reports

  1. Create a PivotTable

  2. Create PivotCharts

  3. Filter Data Using Slicers

  4. Present PivotTable Data Visually

Lesson 4: Using DAX Functions in PowerPivot

  1. Manipulate PowerPivot Data Using DAX Functions

  2. Extract Data from Tables Using Functions

  3. Work with Time Dependent Data

Lesson 5: Distributing PowerPivot Data

  1. Protect Reports

  2. Save Reports in Different File Formats

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.